<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateShopInterviewParentTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('shop_interview_parent', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('city_id')->comment('城市id');
            $table->string('interview_title',255)->comment('探店标题');
            $table->string('interview_theme',255)->comment('探店主题图');
            $table->integer('is_top',4)->comment('是否置顶（1:置顶、0:不置顶）');
            $table->integer('browse_num')->default(1)->comment('浏览量(默认为1，非空)');
            $table->string('interview_content',2048)->comment('探店文章内容');
            $table->string('publisher',32)->comment('发布人');
            $table->integer('status',4)->comment('状态1：生效，0：失效');
            $table->integer('admin_id')->comment('操作人id');
            $table->dateTime('eff_date')->comment('生效时间');
            $table->dateTime('exp_date')->comment('失效时间');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::drop('shops_interview_parent');
    }
}
